On Making Relational Division Comprehensible
نویسنده
چکیده
1 Computer Science Department, University of Wisconsin Parkside, 900 Wood Road, P.O. Box 2000, Kenosha, WI 53141-2000 [mccann at uwp.edu] Abstract Division is the most intellectually challenging of the basic operators of relational algebra. Although its utility is unquestioned, its presentation by many textbooks, and therefore by many instructors, leaves much to be desired. This paper examines the standard approaches used to express division in relational algebra and SQL, explains the derivation of each, and presents a coherent sequence of examples that we have used successfully to teach division to students in introductory database classes.
منابع مشابه
Making Query Coding in SQL Easier by Implementing the SQL Divide Keyword : An Experimental Query Rewriter in Java
Relational Algebra (RA) and structured query language (SQL) are supposed to have a bijective relationship by having the same expressive power. That is, each operation in SQL can be mapped to one RA equivalent and vice versa. Actually, this is an essential fact because in commercial database management systems, every SQL query is translated into equivalent RA expression, which is optimized and e...
متن کاملA Relational Framework to Explain the Town’s Local Actors Decision-Making Mechanism
The life of Towns has become more important and greatly emphasized in recent years and this heralds the arrival of a new era when this type of settlements is introduced as major living and investment capacities. Therefore, it is necessary to study the different aspects of towns in order to plan and manage their development and answer the question about different decision-making mechanism in the...
متن کاملThe Effect of Comprehensible Input and Comprehensible Output on the Accuracy and Complexity of Iranian EFL Learners’ Oral Speech
This study aimed at investigating the relative impact of comprehensible input and comprehensible output on the development of grammatical accuracy and syntactic complexity of Iranian EFL learners’ oral production. Participants were 60 female EFL learners selected from a whole population pool of 80 based on the standard test of IELTS. To investigate the research questions, the participants were ...
متن کاملA Hybrid Grey based Two Steps Clustering and Firefly Algorithm for Portfolio Selection
Considering the concept of clustering, the main idea of the present study is based on the fact that all stocks for choosing and ranking will not be necessarily in one cluster. Taking the mentioned point into account, this study aims at offering a new methodology for making decisions concerning the formation of a portfolio of stocks in the stock market. To meet this end, Multiple-Criteria Decisi...
متن کاملFast and Scalable Relational Division on Database Systems
The Relational Algebra is composed of several operators to assist queries and data manipulation on Relational Databases. The Relational Division operator, particularly, allows simple representations of several queries involving the concept of “for all”, however, the SQL does not have an explicit implementation for it. In this paper, we compare the performance of the best implementation known fo...
متن کامل